{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Tjek","Omregnere","Gl.satsark","kommuner_afd","regnemaskine","Ark1","Satser"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tjek","index":0,"n_rows":84,"n_cols":27,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,"Satser pr. 1-3-2013 til 1-3-2020",null,null,null,null,null,"Slet indtastninger: <Ctrl>+q",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-01"]
[null,{"$f":"VLOOKUP(C10,C61:E64,2,FALSE)","v":{"$error":"#N/A"}},"LØNTJEK",null,null,null,null,null,"OVERENSKOMST: DI / Pleje og omsorg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-01"]
[null,{"$f":"C15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-01"]
[null,null,"Dato på lønseddel",null,null,null,null,null,"Grundløn:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-01"]
[null,null,null,null,null,null,null,null,"grundløn",null,{"$f":"IFERROR(VLOOKUP(stilling,grundløn,VLOOKUP(C6,kolonne_nr,2,TRUE)+3,FALSE)/fuldtidsnorm*$C$18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-01"]
[null,null,{"$f":"IF(C6<>\"\",DATE(YEAR(C6),MONTH(C6)-1,DAY(C6)),\"\")","v":""},null,null,null,null,null,"gruppetillæg (geografi)",null,{"$f":"IFERROR(VLOOKUP(område,gr_tillæg,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE)/fuldtidsnorm*$C$18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-01"]
[null,null,"Stilling:",null,null,null,null,null,"Tillæg:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-01"]
[null,null,null,null,null,null,null,null,"servicetillæg",null,{"$f":"IFERROR(VLOOKUP(1,servicetillæg,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE)/fuldtidsnorm*$C$18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01"]
[null,null,null,null,null,null,null,null,"kvalifikationsløn (års anciennitet)",null,{"$f":"IFERROR(VLOOKUP(J12,anc_tillæg,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,TRUE)/fuldtidsnorm*$C$18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01"]
[null,null,"Område/løngruppe:",null,null,null,null,null,"funktionsløn, lokalt aftalt",null,{"$f":"J14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-01"]
[null,null,null,null,null,null,null,null,"kvalifikationsløn, lokalt aftalt",null,{"$f":"J15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-01"]
[null,null,"Timetal (timer/uge jf. ansættelsesbrev):",null,null,null,null,null,"fast månedsløn",null,{"$f":"SUM(K2:K15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-01"]
[null,null,null,null,null,null,null,null,"timeløn",null,{"$f":"IFERROR((K17/timetal*fuldtidsnorm)*12/1924,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-08-01"]
[null,null,{"$f":"\"(svarende til \"&ROUND(timetal*52/12,2)&\" timer/måned)\"","v":"(svarende til 0 timer/måned)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
[null,null,null,null,null,null,null,null,"Særydelser:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,"merarbejde/udbetalt afsp.",null,{"$f":"K18*(CEILING((J21)*2,1)/2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
[null,null,null,null,null,null,null,null,"overarbejde",null,{"$f":"K18*(1+50%)*(CEILING(J22*2,1)/2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01"]
[null,null,null,null,null,null,null,null,"timer; 18-07",null,{"$f":"IFERROR(J24*VLOOKUP(3,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01"]
[null,null,null,null,null,null,null,null,"timer; lørdag/mandag",null,{"$f":"IFERROR((CEILING(J25*2,1)/2)*VLOOKUP(4,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01"]
[null,null,null,null,null,null,null,null,"timer; søn- og helligdag",null,{"$f":"IFERROR((CEILING(J26*2,1)/2)*K18*VLOOKUP(5,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-01"]
[null,null,null,null,null,null,null,null,"omlagt tjeneste",null,{"$f":"IFERROR(J28*VLOOKUP(1,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01"]
[null,null,null,null,null,null,null,null,"aften/nattimer (3/37) udbetalt",null,{"$f":"J30/37*3*K18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01"]
[null,null,null,null,null,null,null,null,"inddraget fridøgn",null,{"$f":"IFERROR(J32*VLOOKUP(2,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01"]
[null,null,null,null,null,null,null,null,"rådighedsvagt (fra bolig)",null,{"$f":"IFERROR(J34*VLOOKUP(6,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01"]
[null,null,null,null,null,null,null,null,"beklædningsgodtg. (vask)",null,{"$f":"IF(G36<>\"\",VLOOKUP(7,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE)*timetal*52/12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01"]
[null,null,null,null,null,null,null,null,"beklædningsgodtg. (vask og tøj)",null,{"$f":"IF(G37<>\"\",VLOOKUP(8,særydelser,VLOOKUP($C$7,kolonne_nr,2,TRUE)+2,FALSE)*timetal*52/12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01"]
[null,null,null,null,null,null,null,null,"ferieberettiget løn",null,{"$f":"SUM(K21:K38,K17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01"]
[null,null,null,null,null,null,null,null,"særlig opsparing",null,{"$f":"IFERROR(K39*VLOOKUP(1,sær_ops,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-01"]
[null,null,null,null,null,null,null,null,"pensionsgivende løn",null,{"$f":"K39+K41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01"]
[null,null,null,null,null,null,null,null,"Pensionsprocent",null,{"$f":"J45*K43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",{"$f":"IF(J45=\"\",\"\",J45/3)","v":""},{"$f":"IFERROR(J46*$K$43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, arbejdsgiver",{"$f":"IF(J45<>\"\",VLOOKUP(1,sundhedsbidrag,(VLOOKUP(C6,kolonne_nr,2,TRUE)+1),FALSE)+J45/3*2,\"\")","v":""},{"$f":"IFERROR(J47*$K$43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01"]
[null,null,null,null,null,null,null,null,{"$f":"IF(J45=\"\",\"\",\"(inkl. sundhedsbidrag: \"&ROUND((SUM(J46:J47)-J45)*100,2)&\"%)\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01"]
[null,null,0,null,null,null,null,null,null,7.1999999999999995E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01"]
[null,null,1,null,null,null,null,null,null,0.13200000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01"]
[null,null,"Ikke-uddannede, husassist., servicemedarb.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01"]
[null,null,"Hjemmehjælpere",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01"]
[null,null,"Social- og sundhedshj., sygehj. m.fl.",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01"]
[null,null,"Social- og sundhedsass., plejehj.ass., plejere",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01"]

{"sheet":"Omregnere","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"minutter","decimaltal"]
[null,null,30,{"$f":"C3/60","v":0.5}]
[]
[null,null,"Timer pr.\nuge","timer pr.\nmåned"]
[null,null,28.000019999999999,{"$f":"C6*52/12","v":121.33341999999999}]
[]
[null,null,"lokalt\ntillæg\nreduceret","timetal\n/uge el. måned","lokalt \ntillæg \nfuldt"]
[null,null,500,121.33329999999999,{"$f":"IF(D9>1942/52,ROUND(C9/D9*(1924/12),0),ROUND(C9/D9*37,0))","v":661}]

{"sheet":"Gl.satsark","index":2,"n_rows":32,"n_cols":28,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[null,null,"§5a, 1","§5a, 2","§5a, 2","§5b","§7, 1","§7, 1","§9",null,"§ 17, 5","§ 17, 8","§ 18, 1","§ 18, 2","§ 18, 3","§ 19, 1","§ 19, 1",null,null,null,null,null,null,"§25","§25"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
[null,"1. marts 2013","Grundløn","Grundløn","Grundløn","servicetill.","anciennitet","anciennitet","Særlig opsp.",null,"omlagte timer","inddraget",null,null,null,"Rådighed","Rådighed",null,null,null,null,null,null,"Beklædningsgodtgørelse"]
[null,null,null,"gr. 1 og 2","gr. 3 og 4",null,"2 år","6 år",null,null,null,"fridøgn","18-07","lø/ma","sø/hell.","bopæl","vagtvær.",null,null,null,null,null,null,"vask","vask og tøj"]
[1,"Ikke-uddannede, husass., servicemedarb",20211.2,537,1074,505.04,760.74,1360.74,0.01,null,32.78,316.89,25.42,29.67,0.5,34,{"$f":"3/4","v":0.75},null,null,null,null,null,null,0.73,1.67]
[2,"Hjemmehjælpere",20541.48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73,1.67]
[3,"SSHJ, sygehj. m.fl.",21035.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73,1.67]
[4,"SSA, plejehj.ass., plejere",21913.91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73,1.67]
[]
["§ 5a, 2","Områdetillæg"]
[0,0,null,"fuld tid, månedsnorm"]
[1,{"$f":"$D$5","v":537},null,{"$f":"37","v":37},null,null,"2012-03-01","2013-03-01",null,"2012-03-01",32.78,316.89,25.07,29.67,0.5,34,0.75]
[2,{"$f":"$D$5","v":537},null,null,null,"Ikke-uddannede, husass., servicemedarb",19914.59,20211.2,null,"2013-03-01",32.78,316.89,25.42,29.67,0.5,34,0.75]
[3,{"$f":"$E$5","v":1074},null,null,null,"Hjemmehjælpere",20244.87,20541.48]
[4,{"$f":"$E$5","v":1074},null,null,null,"SSHJ, sygehj. m.fl.",20738.689999999999,21035.3]
[null,null,null,null,null,"SSA, plejehj.ass., plejere",21617.3,21913.91]
["§ 7, 1","erfaringstillæg"]
[0,0]
[1,0]
[2,{"$f":"$G$5","v":760.74}]
[3,{"$f":"$G$5","v":760.74}]
[4,{"$f":"$G$5","v":760.74}]
[5,{"$f":"$G$5","v":760.74}]
[6,{"$f":"$H$5","v":1360.74}]
[7,{"$f":"$H$5","v":1360.74}]
[8,{"$f":"$H$5","v":1360.74}]
[]
[]
["§ 16, 1 og 2","pension","arbejdsgiverbidrag"]
[null,"egetbidrag","inkl. sundhedsbidrag"]
[7.1999999999999995E-2,2.4E-2,4.9500000000000002E-2,null,null,{"$f":"A31-B31","v":4.7999999999999994E-2},{"$f":"C31-F31","v":1.5000000000000083E-3}]
[0.13200000000000001,4.3999999999999997E-2,8.9499999999999996E-2,null,null,{"$f":"A32-B32","v":8.8000000000000009E-2},{"$f":"C32-F32","v":1.4999999999999875E-3}]

{"sheet":"kommuner_afd","index":3,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":true,"merged":[]}
["k.nr.","k.navn","løngruppe",null,null,null,null,"Liste, stillinger"]
[165,"Albertslund",4,null,165,1,null,"Ikke-uddannede, husass., servicemedarb",1]
[201,"Allerød",3,null,201,1,null,"Hjemmehjælpere",2]
[420,"Assens",0,null,420,3,null,"SSHJ, sygehj. m.fl.",3]
[151,"Ballerup",4,null,151,1,null,"SSA, plejehj.ass., plejere",4]
[530,"Billund",0,null,530,3]
[400,"Bornholm",0,null,400,1]
[153,"Brøndby",4,null,153,1]
[810,"Brønderslev-Dronninglund",0,null,810,5]
[155,"Dragør",4,null,155,1]
[240,"Egedal",4,null,240,1]
[561,"Esbjerg",1,null,561,3]
[563,"Fanø",0,null,563,3]
[710,"Favrskov",0,null,710,4]
[320,"Faxe",0,null,320,2]
[210,"Fredensborg",3,null,210,1]
[607,"Fredericia",0,null,607,3]
[147,"Frederiksberg",4,null,147,1]
[813,"Frederikshavn",1,null,813,5]
[250,"Frederikssund",3,null,250,1]
[190,"Furesø",4,null,190,1]
[430,"Faaborg-Midtfyn",1,null,430,3]
[157,"Gentofte",4,null,157,1]
[159,"Gladsaxe",4,null,159,1]
[161,"Glostrup",4,null,161,1]
[253,"Greve",4,null,253,2]
[270,"Gribskov",3,null,270,1]
[376,"Guldborgsund",0,null,376,2]
[510,"Haderslev",0,null,510,3]
[260,"Halsnæs",3,null,260,1]
[766,"Hedensted",0,null,766,4]
[217,"Helsingør",3,null,217,1]
[163,"Herlev",4,null,163,1]
[657,"Herning",0,null,657,4]
[219,"Hillerød",3,null,219,1]
[860,"Hjørring",0,null,860,5]
[316,"Holbæk",0,null,316,2]
[661,"Holstebro",0,null,661,4]
[615,"Horsens",0,null,615,4]
[167,"Hvidovre",4,null,167,1]
[169,"Høje-Taastrup",4,null,169,1]
[223,"Hørsholm",3,null,223,1]
[756,"Ikast-Brande",0,null,756,4]
[183,"Ishøj",4,null,183,1]
[849,"Jammerbugt",0,null,849,5]
[326,"Kalundborg",1,null,326,2]
[440,"Kerteminde",1,null,440,3]
[621,"Kolding",0,null,621,3]
[101,"København",4,null,101,1]
[259,"Køge",2,null,259,2]
[482,"Langeland",0,null,482,3]
[350,"Lejre",2,null,350,2]
[665,"Lemvig",0,null,665,4]
[360,"Lolland",0,null,360,2]
[173,"Lyngby-Taarbæk",4,null,173,1]
[825,"Læsø",0,null,825,5]
[846,"Mariagerfjord",0,null,846,5]
[410,"Middelfart",0,null,410,3]
[773,"Morsø",0,null,773,5]
[707,"Norddjurs",0,null,707,4]
[480,"Nordfyn",0,null,480,3]
[450,"Nyborg",1,null,450,3]
[370,"Næstved",1,null,370,2]
[727,"Odder",0,null,727,4]
[461,"Odense",1,null,461,3]
[306,"Odsherred",0,null,306,2]
[730,"Randers",0,null,730,4]
[840,"Rebild",0,null,840,5]
[760,"Ringkøbing-Skjern",0,null,760,4]
[329,"Ringsted",0,null,329,2]
[265,"Roskilde",2,null,265,2]
[230,"Rudersdal",4,null,230,1]
[175,"Rødovre",4,null,175,1]
[741,"Samsø",0,null,741,4]
[740,"Silkeborg",0,null,740,4]
[746,"Skanderborg",1,null,746,4]
[779,"Skive",0,null,779,4]
[330,"Slagelse",1,null,330,2]
[269,"Solrød",2,null,269,2]
[340,"Sorø",0,null,340,2]
[336,"Stevns",0,null,336,2]
[671,"Struer",0,null,671,4]
[479,"Svendborg",0,null,479,3]
[706,"Syddjurs",0,null,706,4]
[540,"Sønderborg",1,null,540,3]
[787,"Thisted",0,null,787,5]
[550,"Tønder",0,null,550,3]
[185,"Tårnby",4,null,185,1]
[187,"Vallensbæk",4,null,187,1]
[573,"Varde",0,null,573,3]
[575,"Vejen",0,null,575,3]
[630,"Vejle",0,null,630,3]
[820,"Vesthimmerland",0,null,820,5]
[791,"Viborg",0,null,791,4]
[390,"Vordingborg",0,null,390,2]
[492,"Ærø",0,null,492,3]
[580,"Aabenraa",0,null,580,3]
[851,"Ålborg",1,null,851,5]
[751,"Århus",2,null,751,4]

{"sheet":"regnemaskine","index":4,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social- og sundhedshjælper, Geografi: Gribskov Kommune"]
[]
[null,null,"Timer/uge",null,28,null,null,null,"Timer/uge",null,31,null,null,null,null,"Timer/uge",null,null,null,null,"Satser:"]
[null,null,"Timetal (faste timer pr. måned)",null,121.333,null,null,null,"Timetal (faste timer pr. måned)",null,134.3433,null,null,null,null,"Timetal (faste timer pr. måned)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(input)","(beregninger)"]
[null,null,"grundløn",null,15918.561672972974,null,null,null,"grundløn",null,17625.477869999999,null,null,null,null,"grundløn",null,null,null,"§ 5a, 1"]
[null,null,"servicetillæg",null,382.19138245322245,null,null,null,"servicetillæg",null,423.17301600000002,null,null,null,null,"gruppetillæg",null,null,null,"§ 5a, 2"]
[null,null,"gruppetillæg",null,812.75452390852388,null,null,null,"gruppetillæg",null,449.95229999999998,null,null,null,null,"servicetillæg",null,null,null,"§ 5b"]
[null,null,"K-løn, ok (års anciennitet)",7,1029.7463602079001,null,null,null,"K-løn, ok (års anciennitet)",1,0,null,null,null,null,"K-løn, ok (års anciennitet)",null,null,null,"§ 7, 1"]
["*",null,"K-løn, lokalt aftalt",3450,2610.8036382536379,null,null,null,"K-løn, lokalt aftalt",null,0,null,null,"*",null,"K-løn, lokalt aftalt",null,null,null,"§ 7, 2"]
["*",null,"K-løn, lokalt aftalt",null,0,null,null,null,"K-løn, lokalt aftalt",null,0,null,null,"*",null,"K-løn, lokalt aftalt",null,null,null,"§ 7, 2"]
["*","u","F-løn, lokalt aftalt",500,500,null,null,null,"F-løn, lokalt aftalt",null,0,null,null,"*","u","F-løn, lokalt aftalt",null,null,null,"§ 6"]
["*",null,"F-løn, lokalt aftalt",null,0,null,null,null,"F-løn, lokalt aftalt",null,0,null,null,"*",null,"F-løn, lokalt aftalt",null,null,null,"§ 6"]
[null,null,"* 'u'; uden reduktion ved deltid",null,null,null,null,null,"fast månedsløn",null,18498.603186,null,null,null,null,"* 'u'; uden reduktion ved deltid"]
[null,null,"fast månedsløn",null,21254.057577796259,null,null,null,"timeløn",null,137.69650727650728,null,null,null,null,"fast månedsløn"]
[null,null,"timeløn",null,175.17128545240175,null,null,null,null,null,null,null,null,null,null,"timeløn"]
[null,null,null,null,null,null,null,null,"merarbejde/udbetalt afsp.",null,0]
[null,null,"merarbejde/udbetalt afsp.",18,3153.0831381432313,null,null,null,"overarbejde",null,0,null,null,null,null,"merarbejde/udbetalt afsp.",null,null,null,"§ 21, 3"]
[null,null,"overarbejde",null,0,null,null,null,null,null,null,null,null,null,null,"overarbejde",null,null,null,"§ 21, 1-2"]
[null,null,null,null,null,null,null,null,"timer; 18-07",null,0]
[null,null,"timer; 18-07",152,3863.84,null,null,null,"timer; lørdag/mandag",4,118.68,null,null,null,null,"timer; 18-07",null,null,null,"§ 18, 1"]
[null,null,"timer; lørdag/mandag",24,712.08,null,null,null,"timer; søn- og helligdag",8,550.7860291060291,null,null,null,null,"timer; lørdag/mandag",null,null,null,"§ 18, 2"]
[null,null,"timer; søn- og helligdag",40,3503.4257090480351,null,null,null,null,null,null,null,null,null,null,"timer; søn- og helligdag",null,null,null,"§ 18, 3"]
[null,null,null,null,null,null,null,null,"3/37 udbetalt",null,0]
[null,null,"3/37 udbetalt",152,2158.8677342241945,null,null,null,"Omlagt tjeneste",null,0,null,null,null,null,"3/37 udbetalt",null,null,null,"§ 18, 5"]
[]
[null,null,"Omlagt tjeneste",null,0,null,null,null,"Rådighedsvagt (bolig)",null,0,null,null,null,null,"Omlagt tjeneste",null,null,null,"§ 17, 5"]
[null,null,null,null,null,null,null,null,"Rådighedsvagt (vagtværelse)"]
[null,null,"Rådighedsvagt (bolig)",null,0,null,null,null,null,null,null,null,null,null,null,"Rådighedsvagt (bolig)",null,null,null,"§ 19, 1"]
[null,null,"Rådighedsvagt (vagtværelse)",null,null,null,null,null,null,null,null,null,null,null,null,"Rådighedsvagt (vagtværelse)",null,null,null,"§ 19, 1"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,0]
[null,null,"Beklædningsgodtg. (vask)",null,0,null,null,null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,null,null,"§ 25"]
[null,null,"Beklædningsgodtg. (vask og tøj)",null,0,null,null,null,"ferieberettiget løn",null,19168.069215106028,null,null,null,null,"Beklædningsgodtg. (vask og tøj)",null,null,null,"§ 25"]
[]
[null,null,"ferieberettiget løn",null,34645.354159211718,null,null,null,"særlig opsparing",null,191.6806921510603,null,null,null,null,"ferieberettiget løn",null,null,null,"§ 27"]
[]
[null,null,"særlig opsparing",null,346.45354159211718,null,null,null,"pensionsgivende løn",null,19359.74990725709,null,null,null,null,"særlig opsparing"]
[]
[null,null,"pensionsgivende løn",null,34991.807700803838,null,null,null,"pensionsprocent",0.13200000000000001,2555.4869877579358,null,null,null,null,"pensionsgivende løn",null,null,null,"§ 16, 1-3"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",4.3999999999999997E-2,851.82899591931186]
[null,null,"pensionsprocent",0.13200000000000001,4618.9186165061064,null,null,null,"pensionsbidrag, arbejdsgiver",8.9499999999999996E-2,1732.6976166995096,null,null,null,null,"pensionsprocent",null,null,null,"§ 16, 1-3"]
[null,null,"pensionsbidrag, medarbejder",4.3999999999999997E-2,1539.6395388353687,null,null,null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",null,null,null,"§ 16, 1-3"]
[null,null,"pensionsbidrag, arbejdsgiver",8.9499999999999996E-2,3131.7667892219433,null,null,null,null,null,null,null,null,null,null,"pensionsbidrag, arbejdsgiver",null,null,null,"§ 16, 1-3"]

{"sheet":"Ark1","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,null,"1998-04-01","2000-04-01"]
[null,0.2,{"$f":"B2","v":0.2},null,null,null,3.57,2.97]
[null,0.4,{"$f":"B3+C2","v":0.60000000000000009},null,null,null,1.25,1.25]
[null,0.5,{"$f":"B4+C3","v":1.1000000000000001},{"$f":"B4","v":0.5},null,null,1.25,0.4]
[null,0.6,{"$f":"B5+C4","v":1.7000000000000002},{"$f":"D4+B5","v":1.1000000000000001},null,null,{"$f":"SUM(G2:G4)","v":6.07},0.8]
[null,0.25,1.9500000000000002,{"$f":"D5+B6","v":1.35},null,null,null,{"$f":"SUM(H2:H5)","v":5.4200000000000008}]
[null,1.22,3.17,2.5700000000000003]
[null,0.4,3.57,2.97]

{"sheet":"Satser","index":6,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8]
["fuld tid, månedsnorm",null,null,null,null,null,null,"2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","2019-03-01","2020-03-01"]
[37,null,null,null,"§5b","servicetill.",1,null,505.04,505.04,505.04,505.04,505.04,505.04,505.04]
[null,null,null,null,"§9","Særlig opsp.",1,null,0.01,1.2999999999999999E-2,1.7000000000000001E-2,0.02,2.7E-2,3.4000000000000002E-2,0.04]
[]
[]
["Kolonnenummer:",null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2]
["2012-03-01",0,null,null,"§ 17, 5","omlagte timer",1,32.78,32.78,{"$f":"I8*(1+J$7)","v":33.271699999999996},33.804047199999999,34.378716002399997,34.93,35.49,36.06]
["2013-03-01",1,null,null,"§ 17, 8","inddraget fridøgn",2,316.89,316.89,321.64334999999994,326.78964359999992,332.34506754119991,337.67,343.07,348.56]
["2014-03-01",2,null,null,"§ 18, 1","18-07",3,25.07,25.42,25.801299999999998,26.214120799999996,26.659760853599995,27.09,27.52,27.96]
["2015-03-01",3,null,null,"§ 18, 2","lø/ma",4,29.67,29.67,30.11505,30.596890800000001,31.117037943599996,31.62,32.119999999999997,32.64]
["2016-03-01",4,null,null,"§ 18, 3","sø/hell.",5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["2017-03-01",5,null,null,"§ 19, 1","Rådighed, fra bopæl",6,34,34,{"$f":"I13*(1+J$7)","v":34.51},{"$f":"J13*(1+K$7)","v":35.062159999999999},{"$f":"K13*(1+L$7)","v":35.658216719999999},36.229999999999997,36.81,37.4]
["2018-03-01",6,null,null,"§25","Bekl.godtg./vask",7,0.73,0.73,0.73,0.73,0.73,0.73,0.73,0.73]
["2019-03-01",7,null,null,"§25","Bekl.godtg./vask og tøj",8,1.67,1.67,1.67,1.67,1.67,1.67,1.67,1.67]
["2020-03-01",8]
[]
[null,null,null,null,"§5a, 1","Grundløn"]
[null,null,null,null,null,"Ikke-uddannede, husassist., servicemedarb.",null,null,20211.2,20547.900000000001,20908.650000000001,21293.45,21694.28,22095.11,22495.94]
[null,null,null,null,null,"Hjemmehjælpere",null,null,20541.48,20878.18,21238.93,21623.73,22024.560000000001,22425.39,22826.22]
[null,null,null,null,null,"Social- og sundhedshj., sygehj. m.fl.",null,null,21035.3,21372,21732.75,22117.55,22518.38,22919.21,23320.04]
[null,null,null,null,null,"Social- og sundhedsass., plejehj.ass., plejere",null,null,21913.91,22250.61,22611.360000000001,22996.16,23396.99,23797.82,24198.65]
[]
[null,null,null,null,"§ 5a, 2","Områdetillæg"]
[null,null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,1,null,537,537,537,537,537,537,537]
[null,null,null,null,null,null,2,null,537,537,537,537,537,537,537]
[null,null,null,null,null,null,3,null,1074,1074,1074,1074,1074,1074,1074]
[null,null,null,null,null,null,4,null,1074,1074,1074,1074,1074,1074,1074]
[]
[null,null,null,null,"§ 7, 1","erfaringstillæg"]
[null,null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,1,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,2,null,760.74,760.74,760.74,760.74,760.74,760.74,760.74]
[null,null,null,null,null,null,3,null,760.74,760.74,760.74,760.74,760.74,760.74,760.74]
[null,null,null,null,null,null,4,null,760.74,760.74,760.74,760.74,760.74,760.74,760.74]
[null,null,null,null,null,null,5,null,760.74,760.74,760.74,760.74,760.74,760.74,760.74]
[null,null,null,null,null,null,6,null,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74]
[null,null,null,null,null,null,7,null,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74]
[null,null,null,null,null,null,8,null,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74,1360.74]
[]
[]
[null,null,null,null,"§ 16, 1 og 2","pension","arbejdsgiverbidrag"]
[null,null,null,null,null,"egetbidrag","inkl. sundhedsbidrag"]
[null,null,null,null,7.1999999999999995E-2,2.4E-2,4.9500000000000002E-2,null,null,null,4.7999999999999994E-2,1.5000000000000083E-3]
[null,null,null,null,0.13200000000000001,4.3999999999999997E-2,8.9499999999999996E-2,null,null,null,8.8000000000000009E-2,1.4999999999999875E-3]
[]
[null,null,null,null,null,"sundhedsbidrag",1,null,1.5E-3,1.5E-3,1.5E-3,1.5E-3,1.5E-3,1.5E-3,1.5E-3,1.5E-3]